Version: Staging

SpdrParentBrkrEvent

SpdrParentBrkrEvent records are published when a new or cxl/replace parent order arrives causes a broker to begin working and again when a parent order terminates and the underlying broker stops working. The initial version contains state and market data from just after the initial risk check and first attempt at generating child orders.

METADATA

Attribute	Value
Topic	3985-parent-orders
MLink Token	ClientTrading
Product	SRTrade
accessType	SELECT

Table Definition

Field	Type	Key	Default Value	Comment
parentNumber	CHAR(19)	PRI	'0000-0000-0000-0000'
recType	enum - EventRecType	PRI	'New'	type of record NewModifyReplaceCloseReject
secKey_at	enum - AssetType		'None'
secKey_ts	enum - TickerSrc		'None'
secKey_tk	VARCHAR(12)		''
secKey_yr	SMALLINT UNSIGNED		0
secKey_mn	TINYINT UNSIGNED		0
secKey_dy	TINYINT UNSIGNED		0
secKey_xx	DOUBLE		0
secKey_cp	enum - CallPut		'Call'
secType	enum - SpdrKeyType		'None'
accnt	VARCHAR(16)		''
spdrSource	enum - SpdrSource		'None'
groupingCode	CHAR(19)		'0000-0000-0000-0000'
orderSide	enum - BuySell		'None'
clientFirm	VARCHAR(16)		''	SR client firm code
altAccnt	TINYTEXT		''	alternate client assigned long account string optional
altUserName	VARCHAR(24)		''	alternate client assigned user name optional
eventNumber	SMALLINT UNSIGNED		0
stageType	enum - SpdrStageType		'None'	parent is a staged order ToolVisible
stageReview	enum - StageReview		'None'
baseParentNumber	CHAR(19)		'0000-0000-0000-0000'	SPDR order number initial number in cancelreplace sequence also source parent for dynamically generated orderseg autohedges
prevParentNumber	BIGINT		0	SPDR order number order being cancelledreplaced zero if none
engineName	TINYTEXT		''	server stripe
ticker_at	enum - AssetType		'None'	SpiderRock underlier stock key
ticker_ts	enum - TickerSrc		'None'	SpiderRock underlier stock key
ticker_tk	VARCHAR(12)		''	SpiderRock underlier stock key
spdrBrokerStatus	enum - SpdrBrokerStatus		'None'
spdrOrderStatus	enum - SpdrOrderStatus		'PendNew'	parent order status
spdrCloseReason	enum - SpdrCloseReason		'None'	parent order close reason if closed
spdrRejectReason	enum - SpdrRejectReason		'None'	parent order reject reason if any
spdrComment	TINYTEXT		''	additional detail closereject reason last child order error
bidPrc	DOUBLE		0	bid nbbo price record publish
askPrc	DOUBLE		0	ask nbbo price record publish
bidIVol	FLOAT		0	bid nbbo ivol record publish
askIVol	FLOAT		0	ask nbbo ivol record publish
bidSize	INT		0	bid size nbbo cum record publish
askSize	INT		0	ask size nbbo cum record publish
uBid	DOUBLE		0	underlier bid price record publish options only
uAsk	DOUBLE		0	underlier ask price record publish options only
surfacePrc	FLOAT		0	SR surface price record publish
surfaceVol	FLOAT		0	SR surface volatility record publish
surfaceYrs	FLOAT		0	SR surface calc value record publish
surfaceSDiv	FLOAT		0	SR surface calc value record publish
surfaceRate	FLOAT		0	SR surface calc value record publish
surfaceUPrc	FLOAT		0	SR surface calc value record publish
surfaceDe	FLOAT		0	SR surface calc value record publish
surfaceGa	FLOAT		0	SR surface calc value record publish
surfaceTh	FLOAT		0	SR surface calc value record publish
surfaceVe	FLOAT		0	SR surface calc value record publish
surfaceRo	FLOAT		0	SR surface calc value record publish
surfacePh	FLOAT		0	SR surface calc value record publish
arriveNbboSize	INT		0	size of the single largest exchange parent order arrival
arriveNbboExch	enum - OptExch		'None'	exchange representing largest size order arrival
arriveCumSize	INT		0	cum size of all exchanges at NBBO price parent order arrival
arriveNumExch	TINYINT UNSIGNED		0	num exchanges making up cum size parent order arrival
arriveLimitSize	INT		0	immediately marketable size up to limit price on parent order arrival
arriveLimitPrc	DOUBLE		0	expected average fill price if all immediately marketable size executed as advertized
avgFillPrc	DOUBLE		0	average fill price of all fills attributed parent order
cumFillQuan	INT		0	cumulative fill quantity attributed to parent order
numChildOrders	SMALLINT UNSIGNED		0	total number of child orders generated by this parent broker parent number
numDayChildOrders	SMALLINT UNSIGNED		0	total number of child orders generated by this parent broker all day base parent number
openOrderSize	INT		0	open order size
actionOrderSize	INT		0	order size available for immediate action note not all algo combinations allow immediate action
riskLimitSize	INT		0	risk limit size distance to most restrictive risk limit associated with this parent order
riskLimitDesc	enum - SpdrRisk		'None'	reason for size reduction identifies the most restrictive risk limit
riskLimitLevel	enum - SpdrRiskLevel		'None'	risk limit level responsible for reduction
riskLimitDetail	TINYTEXT		''	risk limit level responsible for reduction
limitRefUPrc	DOUBLE		0	effective reference underlier price record publish usually either mid or bidask depending on limit type
limitPrice	DOUBLE		0	parent simple prc limit if any
limitVol	FLOAT		0	parent simple vol limit if any
makeLimitPrice	DOUBLE		0	effective order limit price record publish
makeLimitErr	enum - LimitError		'None'	limit price error code if any
makeLimitErrDesc	TINYTEXT		''	additional limit price error descriptive text
takeLimitPrice	DOUBLE		0	effective order limit price record publish
takeLimitErr	enum - LimitError		'None'	limit price error code if any
takeLimitErrDesc	TINYTEXT		''	additional limit price error descriptive text
brokerState	enum - BrokerState		'None'	broker monitor state
makeState	enum - AlgoState		'None'	enum current state of nonmarketable order handler maker
takeState	enum - AlgoState		'None'	enum current state of marketable order handler taker
mktCrossState	enum - MktCrossState		'None'	enum current state of mkt cross handler if any
lastChildEvent	enum - ChildEvent		'None'	most recent child handling event
spdrMktState	enum - SpdrMarketState		'None'	market state code
numOrders	INT		0	number active child orders record send
leavesQty	INT		0	number of active child order contracts sum of all active child orders record send
childOrderLeaves	INT		0	number of open child orders record send
arrivalSDiv	FLOAT		0	effective sdiv rate parent order arrival fixed for life of parent order
arrivalRate	FLOAT		0	effective interest rate parent order arrival fixed for life of parent order
arrivalDDiv	FLOAT		0	effective cumulative discrete dividend parent order arrival fixed for life of parent order
hedgeSecKey_at	enum - AssetType		'None'	autohedge sec key
hedgeSecKey_ts	enum - TickerSrc		'None'	autohedge sec key
hedgeSecKey_tk	VARCHAR(12)		''	autohedge sec key
hedgeSecKey_yr	SMALLINT UNSIGNED		0	autohedge sec key
hedgeSecKey_mn	TINYINT UNSIGNED		0	autohedge sec key
hedgeSecKey_dy	TINYINT UNSIGNED		0	autohedge sec key
hedgeSecType	enum - SpdrKeyType		'None'	autohedge sec type
theoOpx	FLOAT		0	option theo prc from theoVol
theoVol	FLOAT		0	option theo vol from theoModelif any
childOrderMask	INT UNSIGNED		0	bitmask of all exchange for which a child order was generated
priceFormat	enum - PriceFormat		'None'	price display format code
uPriceFormat	enum - PriceFormat		'None'	underlier price display format code
userName	VARCHAR(24)		''	user associated with the most recent parent order
timestamp	DATETIME(6)		'1900-01-01 00:00:00.000000'	timestamp of last modification

PRIMARY KEY DEFINITION (Unique)

Field	Sequence
parentNumber	1
recType	2

CREATE TABLE EXAMPLE QUERY

CREATE TABLE `SRTrade`.`MsgSRParentBrkrEvent` (
    `parentNumber` CHAR(19) NOT NULL DEFAULT '0000-0000-0000-0000',
    `recType` ENUM('New','Modify','Replace','Close','Reject') NOT NULL DEFAULT 'New' COMMENT 'type of record [New,Modify,Replace,Close,Reject]',
    `secKey_at` ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') NOT NULL DEFAULT 'None',
    `secKey_ts` ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','ESX','ANY','CXE','DXE','NXAM','NXBR','NXDUB','NXLS','NXLDN','NXML','NXMLT','NXOS','NXP','EUREX','CEDX','ICEFE') NOT NULL DEFAULT 'None',
    `secKey_tk` VARCHAR(12) NOT NULL DEFAULT '',
    `secKey_yr` SMALLINT UNSIGNED NOT NULL DEFAULT 0,
    `secKey_mn` TINYINT UNSIGNED NOT NULL DEFAULT 0,
    `secKey_dy` TINYINT UNSIGNED NOT NULL DEFAULT 0,
    `secKey_xx` DOUBLE NOT NULL DEFAULT 0,
    `secKey_cp` ENUM('Call','Put','Pair') NOT NULL DEFAULT 'Call',
    `secType` ENUM('None','Stock','Future','Option','MLeg') NOT NULL DEFAULT 'None',
    `accnt` VARCHAR(16) NOT NULL DEFAULT '',
    `spdrSource` ENUM('None','SpdrTicket','SpdrSingle','SRSE','FIX','HedgeTool','TradeHedge','OpenHedge','AutoHedge','Orphan','RiskManager','OrderManager','ManagedOrder','RFQRespSrvr','Legger','SRSEDrop','FixDrop','TicketDrop','SysTest','RFRResponse','AllocOmni','AllocClient','CertGateway','MLegResponse','LeggerX','DropManager','AutoHedgeSrvr','AuctionStrategySrvr','AllocBlockFace','AllocBlockCust','IceChatGateway','EXS2SRC','MLinkResponse','AutoResponderVD','AutoResponderRC','AutoResponderSN','AutoResponderBX','MLink') NOT NULL DEFAULT 'None',
    `groupingCode` CHAR(19) NOT NULL DEFAULT '0000-0000-0000-0000',
    `orderSide` ENUM('None','Buy','Sell') NOT NULL DEFAULT 'None',
    `clientFirm` VARCHAR(16) NOT NULL DEFAULT '' COMMENT 'SR client firm code',
    `altAccnt` TINYTEXT NOT NULL DEFAULT '' COMMENT 'alternate (client assigned) "long" account string (optional)',
    `altUserName` VARCHAR(24) NOT NULL DEFAULT '' COMMENT 'alternate (client assigned) user name (optional)',
    `eventNumber` SMALLINT UNSIGNED NOT NULL DEFAULT 0,
    `stageType` ENUM('None','ModifyAny','ModifyAlgo') NOT NULL DEFAULT 'None' COMMENT 'parent is a staged order [ToolVisible]',
    `stageReview` ENUM('None','Strict','Normal') NOT NULL DEFAULT 'None',
    `baseParentNumber` CHAR(19) NOT NULL DEFAULT '0000-0000-0000-0000' COMMENT 'SPDR order number (initial number in cancel/replace sequence) (also, source parent for dynamically generated orders;eg auto-hedges)',
    `prevParentNumber` BIGINT NOT NULL DEFAULT 0 COMMENT 'SPDR order number (order being cancelled/replaced) (zero if none)',
    `engineName` TINYTEXT NOT NULL DEFAULT '' COMMENT 'server stripe',
    `ticker_at` ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') NOT NULL DEFAULT 'None' COMMENT 'SpiderRock underlier stock key',
    `ticker_ts` ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','ESX','ANY','CXE','DXE','NXAM','NXBR','NXDUB','NXLS','NXLDN','NXML','NXMLT','NXOS','NXP','EUREX','CEDX','ICEFE') NOT NULL DEFAULT 'None' COMMENT 'SpiderRock underlier stock key',
    `ticker_tk` VARCHAR(12) NOT NULL DEFAULT '' COMMENT 'SpiderRock underlier stock key',
    `spdrBrokerStatus` ENUM('None','Updating','Active','Closing','Closed','Rejected','ActiveHold') NOT NULL DEFAULT 'None',
    `spdrOrderStatus` ENUM('PendNew','New','PendClose','Closed','Rejected','SendReject') NOT NULL DEFAULT 'PendNew' COMMENT 'parent order status',
    `spdrCloseReason` ENUM('None','Cancelled','Filled','Replaced','Expired','Limit','System','LegReject','DoneForDay','IOCExpire','UserCxl','NoProgress','TooManyRej','ReplReject','AlgoClose','Restart','InvldParentLimit','FilledRepl','ForceClose','DmaReject','DmaExpire','DmaBrkrCxl','ReviewReject','MarketState','AlgoReject','ReviewTimeout','ChildReject','ChildCancel','ReviewClose','UPrcRange','LegBrkrClosed','ExchRisk','CrossFailed') NOT NULL DEFAULT 'None' COMMENT 'parent order close reason (if closed)',
    `spdrRejectReason` ENUM('None','AccntHold','UnknwnOpt','UnknwnStk','Expired','BadSize','BadOrdNum','DupOrdNum','BadVolPx','BadLmtType','BadMktPrc','BadLimit','SysReject','TestOrder','CustType','NoFirmPos','BadCent','NoSurface','UnknwnAcc','UnknwnRoot','OrdSpacing','BadOptMkt','BadStkMkt','SendFailed','BadExpose','BadPrem','NoOptLeg','Min2Leg','Max6Leg','BadStkSz','BadRatio','BadLegID','DupLegID','MixedRoots','OffMkt','CentVol','CentLeg','CentRng','CentSAtm','CentSpln','CentErr','NoRiskGrp','BadDDivs','NoPricer','CalcErr','TwapLate','TwapTime','NoAcctMap','UserUnk','UserHold','GTCHold','SysException','StkCrossed','BadOrdType','BadSSaleFlag','NoBorrow','NoFacilitateAccnt','UnknwnFut','MktNotOpen','NoRoutes','NoLocate','SSaleRstr','NoLegs','BadSide','BadLegKeyType','UnknwnRefStk','BadRefMktPrc','UnknwnRefFut','UnknwnRefAtm','BadRefVe','BadProdDef','StkOddLot','RiskException','MaxParticipation','MarExemptHold','NoMarRec','NullCounter','StkQty','FutQty','OptQty','StkDDelta','FutDDelta','OptDDelta','StkClsOnly','StkDisabled','FutClsOnly','FutDisabled','OptClsOnly','OptDisabled','OrderMargin','AccMargin','DayMargin','OpenExpose','DayLnDDelta','DayShDDelta','DayAbsDDelta','DayLnWtVega','DayShWtVega','DayAbsWtVega','DayLnNValue','DayShNValue','DayAbsNValue','AccFrozen','ConfigErr','NoFMFuture','NoLinkage','NoProdDef','BadRiskID','InvldAutoH','LegChange','CxlSpacing','BadHedgeInst','TooLateToReduce','PendCxlRepl','InvldCxlRepl','InvldCxl','DmaReject','NoUPrc','TwapSteps','UnknwnFirm','NoSSaleFlg','AccntNotMM','BadSource','VwapLate','AlreadyFilled','UnknownSecKey','InvldGTD','CutoffTime','ParentShape','NoFaceSide','NoFaceLegs','AuctionSize','InvldClFirm','BadLegBrkr','NoLegBrkr','StkLegNotAllowed','BadLeadSide','UnknwnRefUnd','ExecEngineType','NoExchAvail','SelfTrade','PointValueErr','StkCollar','FutCollar','OptCollar','LmtCollar','RefUPrcErr','InvldUser','InvldAccnt','UnknownCrossId','WidUMkt','UMktCls','UPrcRange','RiskCollarRng') NOT NULL DEFAULT 'None' COMMENT 'parent order reject reason (if any)',
    `spdrComment` TINYTEXT NOT NULL DEFAULT '' COMMENT 'additional detail (close/reject reason; last child order error)',
    `bidPrc` DOUBLE NOT NULL DEFAULT 0 COMMENT 'bid (nbbo) price @ record publish',
    `askPrc` DOUBLE NOT NULL DEFAULT 0 COMMENT 'ask (nbbo) price @ record publish',
    `bidIVol` FLOAT NOT NULL DEFAULT 0 COMMENT 'bid (nbbo) ivol @ record publish',
    `askIVol` FLOAT NOT NULL DEFAULT 0 COMMENT 'ask (nbbo) ivol @ record publish',
    `bidSize` INT NOT NULL DEFAULT 0 COMMENT 'bid size (nbbo cum) @ record publish',
    `askSize` INT NOT NULL DEFAULT 0 COMMENT 'ask size (nbbo cum) @ record publish',
    `uBid` DOUBLE NOT NULL DEFAULT 0 COMMENT 'underlier bid price @ record publish (options only)',
    `uAsk` DOUBLE NOT NULL DEFAULT 0 COMMENT 'underlier ask price @ record publish (options only)',
    `surfacePrc` FLOAT NOT NULL DEFAULT 0 COMMENT 'SR surface price @ record publish',
    `surfaceVol` FLOAT NOT NULL DEFAULT 0 COMMENT 'SR surface volatility @ record publish',
    `surfaceYrs` FLOAT NOT NULL DEFAULT 0 COMMENT 'SR surface calc value @ record publish',
    `surfaceSDiv` FLOAT NOT NULL DEFAULT 0 COMMENT 'SR surface calc value @ record publish',
    `surfaceRate` FLOAT NOT NULL DEFAULT 0 COMMENT 'SR surface calc value @ record publish',
    `surfaceUPrc` FLOAT NOT NULL DEFAULT 0 COMMENT 'SR surface calc value @ record publish',
    `surfaceDe` FLOAT NOT NULL DEFAULT 0 COMMENT 'SR surface calc value @ record publish',
    `surfaceGa` FLOAT NOT NULL DEFAULT 0 COMMENT 'SR surface calc value @ record publish',
    `surfaceTh` FLOAT NOT NULL DEFAULT 0 COMMENT 'SR surface calc value @ record publish',
    `surfaceVe` FLOAT NOT NULL DEFAULT 0 COMMENT 'SR surface calc value @ record publish',
    `surfaceRo` FLOAT NOT NULL DEFAULT 0 COMMENT 'SR surface calc value @ record publish',
    `surfacePh` FLOAT NOT NULL DEFAULT 0 COMMENT 'SR surface calc value @ record publish',
    `arriveNbboSize` INT NOT NULL DEFAULT 0 COMMENT 'size of the single largest exchange @ parent order arrival',
    `arriveNbboExch` ENUM('None','AMEX','BOX','CBOE','ISE','NYSE','PHLX','NSDQ','BATS','C2','NQBX','MIAX','GMNI','CME','CBOT','NYMEX','COMEX','ICE','EDGO','MCRY','MPRL','SDRK','DQTE','EMLD','CFE','MEMX','EUREX','CEDX','NXAM','NXBR','NXLS','NXML','NXOS','NXP','ICEFE') NOT NULL DEFAULT 'None' COMMENT 'exchange representing largest size @ order arrival',
    `arriveCumSize` INT NOT NULL DEFAULT 0 COMMENT 'cum size of all exchanges at NBBO price @ parent order arrival',
    `arriveNumExch` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'num exchanges making up cum size @ parent order arrival',
    `arriveLimitSize` INT NOT NULL DEFAULT 0 COMMENT 'immediately marketable size up to limit price on parent order arrival',
    `arriveLimitPrc` DOUBLE NOT NULL DEFAULT 0 COMMENT 'expected average fill price if all immediately marketable size executed as advertized',
    `avgFillPrc` DOUBLE NOT NULL DEFAULT 0 COMMENT 'average fill price of all fills attributed parent order',
    `cumFillQuan` INT NOT NULL DEFAULT 0 COMMENT 'cumulative fill quantity attributed to parent order',
    `numChildOrders` SMALLINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'total number of child orders generated by this parent broker (parent number)',
    `numDayChildOrders` SMALLINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'total number of child orders generated by this parent broker (all day; base parent number)',
    `openOrderSize` INT NOT NULL DEFAULT 0 COMMENT 'open order size',
    `actionOrderSize` INT NOT NULL DEFAULT 0 COMMENT 'order size available for immediate action (note: not all algo combinations allow immediate action)',
    `riskLimitSize` INT NOT NULL DEFAULT 0 COMMENT 'risk limit size (distance to most restrictive risk limit associated with this parent order)',
    `riskLimitDesc` ENUM('None','NullCounter','StkClsOnly','StkDisabled','FutClsOnly','FutDisabled','OptClsOnly','OptDisabled','OrderMargin','AccMargin','DayMargin','OpenExpose','DayLnDDelta','DayShDDelta','DayAbsDDelta','DayLnWtVe','DayShWtVe','DayAbsWtVe','DayLnNValue','DayShNValue','DayAbsNValue','StkImpact','FutImpact','OptImpact','NullMRC','NullSRC','DDeltaLn','DDeltaSh','DDeltaAbs','WtVegaLn','WtVegaSh','WtVegaAbs','NValueLn','NValueSh','NValueAbs','CtrlDisable','AccEmaDdLn','AccEmaDdSh','AccEmaWvLn','AccEmaWvSh','SymEmaDdLn','SymEmaDdSh','SymEmaWvLn','SymEmaWvSh','ExpDDeltaLn','ExpDDeltaSh','ExpWtVegaLn','ExpWtVegaSh','ExpRm6Ln','ExpRm6Sh','SymDDeltaLn','SymDDeltaSh','SymVegaLn','SymVegaSh','SymWtVegaLn','SymWtVegaSh','SymRm7Ln','SymRm7Sh','GrpDdLn','GrpDdSh','GrpOptQtyLn','GrpOptQtySh','GrpOptQtyAbs','GrpVegaLn','GrpVegaSh','GrpVegaAbs','GrpRm1Ln','GrpRm1Sh','GrpRm1Abs','GrpRm2Ln','GrpRm2Sh','GrpRm3Ln','GrpRm3Sh','GrpRm4Ln','GrpRm4Sh','GrpRm5Ln','GrpRm5Sh','UDn50','UUp50','UDn15','UUp15','OrderSize','SysErr','StkErr','FutErr','OptErr','SSaleErr','SSaleRstr','StkSellLmt','Locate','StkRstct','SizeCap','ZeroCross','PreOpnQ','TrgWait','WaitStart','WaitTrigger','LegStep','TwapStep','MktNotReady','MaxRisk','NoStkBrw','BadMkt','BadLmt','NoAltOrdId','InvldBrkr','MaxChildOrders','MktHalted','UPrcErr','MinUBid','MaxUAsk','PreStart','ClntRteDn','ActiveSize','MktClosed','NoDDeltaMult','InvldDelta','RiskCollarRng','DayFutCnBot','DayFutCnSld','DayFutCnAbs','AccFutCnAbs') NOT NULL DEFAULT 'None' COMMENT 'reason for size reduction (identifies the most restrictive risk limit)',
    `riskLimitLevel` ENUM('None','MarExsOnSponsLvl','MarExsOnSponsTkLvl','MarExsOnCoreLvl','MarExsOnCoreTkLvl','MarSponsOnCoreLvl','MarSponsOnCoreTkLvl','MarCoreOnCoreLvl','MarCoreOnCoreTkLvl','MarCoreOnSubLvl','MarCoreOnSubTkLvl','MarCoreOnAccntLvl','MarCoreOnAccntTkLvl','MarSubOnAccntLvl','MarSubOnAccntTkLvl','MarCoreOnCustomLvl','MarCoreOnCustomTkLvl','MarSubOnCustomLvl','MarSubOnCustomTkLvl','UserLvl','UserTkLvl','AccntLvl','AccntTkLvl','CFirmLvl','CFirmTkLvl','RiskGroup','HardLvl','SoftLvl','GblTkLvl') NOT NULL DEFAULT 'None' COMMENT 'risk limit level responsible for reduction',
    `riskLimitDetail` TINYTEXT NOT NULL DEFAULT '' COMMENT 'risk limit level responsible for reduction',
    `limitRefUPrc` DOUBLE NOT NULL DEFAULT 0 COMMENT 'effective reference underlier price @ record publish (usually either mid or bid/ask depending on limit type)',
    `limitPrice` DOUBLE NOT NULL DEFAULT 0 COMMENT 'parent simple prc limit (if any)',
    `limitVol` FLOAT NOT NULL DEFAULT 0 COMMENT 'parent simple vol limit (if any)',
    `makeLimitPrice` DOUBLE NOT NULL DEFAULT 0 COMMENT 'effective order limit price @ record publish',
    `makeLimitErr` ENUM('None','LmtPrcRng','NoStkNbbo','LowStkNbbo','WideStkNbbo','CrossStkNbbo','VolCalcErr','RefUPrcErr','RefDeltaRng','dUPrcRng','BadLmtType','LmtPrcErr','BadCent','CentVolLmt','BadSurf','CentPrcLmt','NoOptNbbo','WideOptNbbo','dYrsRng','BadRefDelta','BadStkNbbo','InvldMkt','BadVolLmt','CrossOptNbbo','NoFutNbbo','LowFutNbbo','WideFutNbbo','CrossFutNbbo','InvldRefMkt','TiedRtnRng','InvldAdjType','ProdDefErr','PrcBandViol','SysErr','NoQteProb','ProbRng','LmtClass','NoAlphaLvl','SurfErr','ProbErr','BadMult','NoUPrc','BadAlphaLvl','LegLimitErr','AuxLimit','NoFutMktSz','FutMktNotOpn','StaleProb','NoStkObj','NoFutObj','NoOptObj','dOpxGaRng','FadeProb','SurfNoTrd','SurfAge','SurfMktSess','SurfVolRng','SurfPrc','NoSurface','SurfLowCCnt','SurfLowPCnt','SurfFitPrcErr','SurfBidAskMiss','SurfLowCounter','SurfDefaultSkew','SurfSessionMiss','SurfBaseErr','SurfSwitchDelay','SurfWideMktV','SurfWideMktP','SurfUWidthEma','SurfCCntEma','SurfPCntEma','SurfVWidthEma','SurfPWidthEma','SurfWideUMkt','LowOptPrc','LegURng','WideMarket','dOpxThRng','NA','InvldMktWidth','Except','BadProbRecord','InterpErr','SurfImprErr','JoinImprErr','JoinItrpErr','JoinFadeErr','NoLimit') NOT NULL DEFAULT 'None' COMMENT 'limit price error code (if any)',
    `makeLimitErrDesc` TINYTEXT NOT NULL DEFAULT '' COMMENT 'additional limit price error descriptive text',
    `takeLimitPrice` DOUBLE NOT NULL DEFAULT 0 COMMENT 'effective order limit price @ record publish',
    `takeLimitErr` ENUM('None','LmtPrcRng','NoStkNbbo','LowStkNbbo','WideStkNbbo','CrossStkNbbo','VolCalcErr','RefUPrcErr','RefDeltaRng','dUPrcRng','BadLmtType','LmtPrcErr','BadCent','CentVolLmt','BadSurf','CentPrcLmt','NoOptNbbo','WideOptNbbo','dYrsRng','BadRefDelta','BadStkNbbo','InvldMkt','BadVolLmt','CrossOptNbbo','NoFutNbbo','LowFutNbbo','WideFutNbbo','CrossFutNbbo','InvldRefMkt','TiedRtnRng','InvldAdjType','ProdDefErr','PrcBandViol','SysErr','NoQteProb','ProbRng','LmtClass','NoAlphaLvl','SurfErr','ProbErr','BadMult','NoUPrc','BadAlphaLvl','LegLimitErr','AuxLimit','NoFutMktSz','FutMktNotOpn','StaleProb','NoStkObj','NoFutObj','NoOptObj','dOpxGaRng','FadeProb','SurfNoTrd','SurfAge','SurfMktSess','SurfVolRng','SurfPrc','NoSurface','SurfLowCCnt','SurfLowPCnt','SurfFitPrcErr','SurfBidAskMiss','SurfLowCounter','SurfDefaultSkew','SurfSessionMiss','SurfBaseErr','SurfSwitchDelay','SurfWideMktV','SurfWideMktP','SurfUWidthEma','SurfCCntEma','SurfPCntEma','SurfVWidthEma','SurfPWidthEma','SurfWideUMkt','LowOptPrc','LegURng','WideMarket','dOpxThRng','NA','InvldMktWidth','Except','BadProbRecord','InterpErr','SurfImprErr','JoinImprErr','JoinItrpErr','JoinFadeErr','NoLimit') NOT NULL DEFAULT 'None' COMMENT 'limit price error code (if any)',
    `takeLimitErrDesc` TINYTEXT NOT NULL DEFAULT '' COMMENT 'additional limit price error descriptive text',
    `brokerState` ENUM('None','Start','MarNotEnabled','CloseRequest','WaitTrigger','ChkBrkrFail','NotValid','StepChk','ResetOff','ResetOn','ResetActive','TwapChkWait','TwapChk','VwapChk','VwapVlmFail','CleanupBrkr','AlgoNormal','StkClosed','StkHalted','StkNotOpn','FutClosed','FutHalted','FutNotOpn','TryCxlChildrenCont','BrkrPendNew','BrkrPendClose','BrkrPreOpnQ','BrkrPendRpl','BrkrWaitTrig','TryCxlChildrenTerm','PendChildCxl','Done','BrkrClosing','BrkrClosed','BrkrRejected','MktHalted','LimitErr','RiskHold','SecTypeErr','MktDataErr','LmtErr','StkNotRdy','MinUPrcLmt','MaxUPrcLmt','InvldSysEnv','InvldRunStatus','InvldEngineType','MarketClosed','GoodTillDttmReached','TestExpired','AutoHedgeExpired','EngineClosed','EngPreOpn','OutsideMktDay','OutsideMktDay2','MaxChildRejects','IOCExpired','ProgressTimeout','NoStreetFixSession','StreetFixNotLoggedIn','StreetFixTimeout','HedgeHold','NewParent','AddUpdate','ClearAction','UpdateLegLimit','Exception','AlgoWorking','ReviewReject','ReviewPending','ReviewTimeout','PendTrigger','PendReview','PendCxlRpl','Suspended','LeggerWait','NoStkMkt','CkIncrProgress','TriggerHold','SwitchMOC','HoldMOC','VwapStepWait','MaxChildOrders','ActiveHold') NOT NULL DEFAULT 'None' COMMENT 'broker monitor state',
    `makeState` ENUM('None','Posting','PendPost','OffMkt','BadFirmType','NoExchSet','BadOrder','NoPostSize','MaxActive','ActWait','SendHold','LmtErr','LmtRng','LmtPx','PendAct','MaxSize','OddLot','IWait','Quiet','Fade','InVld','MaxPSz','MaxOrd','MaxPxLv','MaxPec1','MaxPec2','MaxPec3','TryPxLvl1','TryPxLvl2','TryPxLvl3','DonePxLvl1','DonePxLvl2','DonePxLvl3','SendPxLvl1','SendPxLvl2','SendPxLvl3','NoExchQte','CrtErr','SizeWait','NbboHold','ExchHold','CxlRpl','SndErr','OldMdl','ExchRte','PrcHold','ModelErr','LowProb','PostWith','PostBhnd','NoModel','NoOptQte','NoStkQte','RiskHold','SurfHold','NoFutQte','NoStkPrt','PostClr','NoQte','PHold','StkEnv','OptEnv','FutEnv','TryExch','CkSend','PredMiss','SysEnv','NoExchAvail','PostWide','ZeroLmt','LockSkip','ProbLmt','PrcLmt','NoActSz','CkAdd','Locked','PendCxl','NewWait','EnterLimit','EnterPost','EnterFlow','EnterMake','EnterSeeker','EnterMatrix','EnterLegger','SendOK','SendFail','Except','Filled','TrySend','BadMkt','SysError','MktDataErr','TickSizeErr','NullParent','NoUPrc','TryTake','NoProb','SendThrtl','ProbErr','PendClear','MaxExCnt','MaxExpose','NoExDest','ReachDelay','ReachWait','ClearWait','CxlWait','LeavesErr','FeeWait','ActMaker','WthFade','SyncHold','AuctionDone','BadUDefKey','UDefReject','PendUDef','ExchRej','TrySendSprd','Working','RejDelay','NoStepSz','UpdtLegBrkr','LegNewWait','LegNoChng','LegBadMkt','LegImprvDelay','LegUpdtLmt','LegUpdtErr','NoExchList','PendTake','LeggerDone','MaxChildren','RiskCxlThrtl','FlashWait','NoImpRm','RollVlm','MoveVlm','AccelTake','NoMassQte','MktNotOpen','CreateSprd','InvldExch','RFQTimeout','TrySendRFQ','EnterResponder','CreateErr','LockFail','NoRoute','UnkCrossId','SelfTrade','ImpactHold','LegWait','TwapWait','InvalidSpread','PegHold','OffPeg','ChildCxlHold','CheckBrkr','FaceDone','CtrlSize','FacePromote','MatrixDone','TakeVlmHold','NoExchRoute','ExchNoMake','ExchWrking','ExchSingle','ExchMakeHold','ExchBrkrSkip','ExchNoQte','ExchMaxFee','ExchOffMkt','ExchNoImprv','FlashInitErr','FlashCalcErr','MarketClosed','ExchActOrd','ExchMaxFeeP','ExchNoRte','TakeFail','BestPxLmt','PennyProtected','WaitSquare','NotActive','RteOpnLmt','NoTiedMaker','WaitTrigger','CrossPending','NoResponders','SendThrtlHiLat','SendThrtlNewWin','SendThrtlRteQGap','SendThrtlRteQSz','SendThrtlRteQAge','ExRiskMgmt','RouteDayMax','ZeroChildSize','ExchTakeSkip','ExchNoSzSkip','ExchNoQteSkip','ExchNullRte','ExchRteFail','CxlCntWait','TryGetRoutes','GetMakePrice','MktPreOpen','MktClosed','MktHalted','PendCross','PendSweep','CrossMkt','Sweeping','SweepMiss','NoCrossSize','NoFace','ConfigErr','NExchOffMkt','CrossClear','LiqReqPend','CxlThrottle','RouteSafeMode','Crossing','CrossComplete','CrossExpired') NOT NULL DEFAULT 'None' COMMENT '[enum] current state of non-marketable order handler (maker)',
    `takeState` ENUM('None','Posting','PendPost','OffMkt','BadFirmType','NoExchSet','BadOrder','NoPostSize','MaxActive','ActWait','SendHold','LmtErr','LmtRng','LmtPx','PendAct','MaxSize','OddLot','IWait','Quiet','Fade','InVld','MaxPSz','MaxOrd','MaxPxLv','MaxPec1','MaxPec2','MaxPec3','TryPxLvl1','TryPxLvl2','TryPxLvl3','DonePxLvl1','DonePxLvl2','DonePxLvl3','SendPxLvl1','SendPxLvl2','SendPxLvl3','NoExchQte','CrtErr','SizeWait','NbboHold','ExchHold','CxlRpl','SndErr','OldMdl','ExchRte','PrcHold','ModelErr','LowProb','PostWith','PostBhnd','NoModel','NoOptQte','NoStkQte','RiskHold','SurfHold','NoFutQte','NoStkPrt','PostClr','NoQte','PHold','StkEnv','OptEnv','FutEnv','TryExch','CkSend','PredMiss','SysEnv','NoExchAvail','PostWide','ZeroLmt','LockSkip','ProbLmt','PrcLmt','NoActSz','CkAdd','Locked','PendCxl','NewWait','EnterLimit','EnterPost','EnterFlow','EnterMake','EnterSeeker','EnterMatrix','EnterLegger','SendOK','SendFail','Except','Filled','TrySend','BadMkt','SysError','MktDataErr','TickSizeErr','NullParent','NoUPrc','TryTake','NoProb','SendThrtl','ProbErr','PendClear','MaxExCnt','MaxExpose','NoExDest','ReachDelay','ReachWait','ClearWait','CxlWait','LeavesErr','FeeWait','ActMaker','WthFade','SyncHold','AuctionDone','BadUDefKey','UDefReject','PendUDef','ExchRej','TrySendSprd','Working','RejDelay','NoStepSz','UpdtLegBrkr','LegNewWait','LegNoChng','LegBadMkt','LegImprvDelay','LegUpdtLmt','LegUpdtErr','NoExchList','PendTake','LeggerDone','MaxChildren','RiskCxlThrtl','FlashWait','NoImpRm','RollVlm','MoveVlm','AccelTake','NoMassQte','MktNotOpen','CreateSprd','InvldExch','RFQTimeout','TrySendRFQ','EnterResponder','CreateErr','LockFail','NoRoute','UnkCrossId','SelfTrade','ImpactHold','LegWait','TwapWait','InvalidSpread','PegHold','OffPeg','ChildCxlHold','CheckBrkr','FaceDone','CtrlSize','FacePromote','MatrixDone','TakeVlmHold','NoExchRoute','ExchNoMake','ExchWrking','ExchSingle','ExchMakeHold','ExchBrkrSkip','ExchNoQte','ExchMaxFee','ExchOffMkt','ExchNoImprv','FlashInitErr','FlashCalcErr','MarketClosed','ExchActOrd','ExchMaxFeeP','ExchNoRte','TakeFail','BestPxLmt','PennyProtected','WaitSquare','NotActive','RteOpnLmt','NoTiedMaker','WaitTrigger','CrossPending','NoResponders','SendThrtlHiLat','SendThrtlNewWin','SendThrtlRteQGap','SendThrtlRteQSz','SendThrtlRteQAge','ExRiskMgmt','RouteDayMax','ZeroChildSize','ExchTakeSkip','ExchNoSzSkip','ExchNoQteSkip','ExchNullRte','ExchRteFail','CxlCntWait','TryGetRoutes','GetMakePrice','MktPreOpen','MktClosed','MktHalted','PendCross','PendSweep','CrossMkt','Sweeping','SweepMiss','NoCrossSize','NoFace','ConfigErr','NExchOffMkt','CrossClear','LiqReqPend','CxlThrottle','RouteSafeMode','Crossing','CrossComplete','CrossExpired') NOT NULL DEFAULT 'None' COMMENT '[enum] current state of marketable order handler (taker)',
    `mktCrossState` ENUM('None','Hold','NoHandler','OrderPending','CheckPending','BrkrNotActive','ExchHold','InvldBrkr','Filled','MktOpnCutoff','MktClsCutoff','InvldHandler','SendHold','NoAvailSize','NoRiskSize','LimitErr','MaxChildOrders','OpenOrder','InvldCrossType','CanSendFail','TrySend','CreateErr','SendErr','OrderPosted','ChildCxlHold','NoRoute','AuctionClosed','RespondWait','ZeroCustSize','AuctionPending','ChildCxlPending','TryCross','TryCrossFail','Exception','CustCancel','LockMiss','CrossPending','ChildCrossPending','ChildAllocPending','CrossClosed','ChildSweepPending','CustFilled') NOT NULL DEFAULT 'None' COMMENT '[enum] current state of mkt cross handler (if any)',
    `lastChildEvent` ENUM('None','OK','ChildError','EnvNotValid','NoOrdSide','OptNotReady','ChildErrHold','ImmCxl','MaxChildOrders','RollVlm','MoveVlm') NOT NULL DEFAULT 'None' COMMENT 'most recent child handling event',
    `spdrMktState` ENUM('None','PreOpen','Open','Closed','Halted','EngNotOpen','Exception') NOT NULL DEFAULT 'None' COMMENT 'market state code',
    `numOrders` INT NOT NULL DEFAULT 0 COMMENT 'number active child orders @ record send',
    `leavesQty` INT NOT NULL DEFAULT 0 COMMENT 'number of active child order contracts (sum of all active child orders) @ record send',
    `childOrderLeaves` INT NOT NULL DEFAULT 0 COMMENT 'number of open child orders @ record send',
    `arrivalSDiv` FLOAT NOT NULL DEFAULT 0 COMMENT 'effective sdiv rate @ parent order arrival (fixed for life of parent order)',
    `arrivalRate` FLOAT NOT NULL DEFAULT 0 COMMENT 'effective interest rate @ parent order arrival (fixed for life of parent order)',
    `arrivalDDiv` FLOAT NOT NULL DEFAULT 0 COMMENT 'effective cumulative discrete dividend @ parent order arrival (fixed for life of parent order)',
    `hedgeSecKey_at` ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') NOT NULL DEFAULT 'None' COMMENT 'auto-hedge sec key',
    `hedgeSecKey_ts` ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','ESX','ANY','CXE','DXE','NXAM','NXBR','NXDUB','NXLS','NXLDN','NXML','NXMLT','NXOS','NXP','EUREX','CEDX','ICEFE') NOT NULL DEFAULT 'None' COMMENT 'auto-hedge sec key',
    `hedgeSecKey_tk` VARCHAR(12) NOT NULL DEFAULT '' COMMENT 'auto-hedge sec key',
    `hedgeSecKey_yr` SMALLINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'auto-hedge sec key',
    `hedgeSecKey_mn` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'auto-hedge sec key',
    `hedgeSecKey_dy` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'auto-hedge sec key',
    `hedgeSecType` ENUM('None','Stock','Future','Option','MLeg') NOT NULL DEFAULT 'None' COMMENT 'auto-hedge sec type',
    `theoOpx` FLOAT NOT NULL DEFAULT 0 COMMENT 'option theo prc (from theoVol)',
    `theoVol` FLOAT NOT NULL DEFAULT 0 COMMENT 'option theo vol (from theoModel;if any)',
    `childOrderMask` INT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'bit-mask of all exchange for which a child order was generated',
    `priceFormat` ENUM('None','N0','N1','N2','N3','N4','N5','N6','N7','F4','F8','Q8','F16','F32','H32','Q32','F64','H64','FullPenny','PartPenny','PartNickle','EQT','V1','V2','V3','V4','V5','V6','V7','V8','V9','V10','V11','V12','V13','V14','V15','A0','A1','A2','A3','A4','A5','A6','A7','E32') NOT NULL DEFAULT 'None' COMMENT 'price display format code',
    `uPriceFormat` ENUM('None','N0','N1','N2','N3','N4','N5','N6','N7','F4','F8','Q8','F16','F32','H32','Q32','F64','H64','FullPenny','PartPenny','PartNickle','EQT','V1','V2','V3','V4','V5','V6','V7','V8','V9','V10','V11','V12','V13','V14','V15','A0','A1','A2','A3','A4','A5','A6','A7','E32') NOT NULL DEFAULT 'None' COMMENT 'underlier price display format code',
    `userName` VARCHAR(24) NOT NULL DEFAULT '' COMMENT 'user associated with the most recent parent order',
    `timestamp` DATETIME(6) NOT NULL DEFAULT '1900-01-01 00:00:00.000000' COMMENT 'timestamp of last modification',
    CONSTRAINT nonnegative_parentNumber CHECK(ASCII(parentNumber) < 56),
    CONSTRAINT nonnegative_groupingCode CHECK(ASCII(groupingCode) < 56),
    CONSTRAINT nonnegative_baseParentNumber CHECK(ASCII(baseParentNumber) < 56),
    PRIMARY KEY USING HASH (`parentNumber`,`recType`)
) ENGINE=SRSE DEFAULT CHARSET=LATIN1 COMMENT='SpdrParentBrkrEvent records are published when a new or cxl/replace parent order arrives causes a broker to begin working and again when a parent order terminates and the underlying broker stops working.  The initial version contains state and market data from just after the initial risk check and first attempt at generating child orders.';

SELECT TABLE EXAMPLE QUERY

SELECT
    `parentNumber`,
    `recType`,
    `secKey_at`,
    `secKey_ts`,
    `secKey_tk`,
    `secKey_yr`,
    `secKey_mn`,
    `secKey_dy`,
    `secKey_xx`,
    `secKey_cp`,
    `secType`,
    `accnt`,
    `spdrSource`,
    `groupingCode`,
    `orderSide`,
    `clientFirm`,
    `altAccnt`,
    `altUserName`,
    `eventNumber`,
    `stageType`,
    `stageReview`,
    `baseParentNumber`,
    `prevParentNumber`,
    `engineName`,
    `ticker_at`,
    `ticker_ts`,
    `ticker_tk`,
    `spdrBrokerStatus`,
    `spdrOrderStatus`,
    `spdrCloseReason`,
    `spdrRejectReason`,
    `spdrComment`,
    `bidPrc`,
    `askPrc`,
    `bidIVol`,
    `askIVol`,
    `bidSize`,
    `askSize`,
    `uBid`,
    `uAsk`,
    `surfacePrc`,
    `surfaceVol`,
    `surfaceYrs`,
    `surfaceSDiv`,
    `surfaceRate`,
    `surfaceUPrc`,
    `surfaceDe`,
    `surfaceGa`,
    `surfaceTh`,
    `surfaceVe`,
    `surfaceRo`,
    `surfacePh`,
    `arriveNbboSize`,
    `arriveNbboExch`,
    `arriveCumSize`,
    `arriveNumExch`,
    `arriveLimitSize`,
    `arriveLimitPrc`,
    `avgFillPrc`,
    `cumFillQuan`,
    `numChildOrders`,
    `numDayChildOrders`,
    `openOrderSize`,
    `actionOrderSize`,
    `riskLimitSize`,
    `riskLimitDesc`,
    `riskLimitLevel`,
    `riskLimitDetail`,
    `limitRefUPrc`,
    `limitPrice`,
    `limitVol`,
    `makeLimitPrice`,
    `makeLimitErr`,
    `makeLimitErrDesc`,
    `takeLimitPrice`,
    `takeLimitErr`,
    `takeLimitErrDesc`,
    `brokerState`,
    `makeState`,
    `takeState`,
    `mktCrossState`,
    `lastChildEvent`,
    `spdrMktState`,
    `numOrders`,
    `leavesQty`,
    `childOrderLeaves`,
    `arrivalSDiv`,
    `arrivalRate`,
    `arrivalDDiv`,
    `hedgeSecKey_at`,
    `hedgeSecKey_ts`,
    `hedgeSecKey_tk`,
    `hedgeSecKey_yr`,
    `hedgeSecKey_mn`,
    `hedgeSecKey_dy`,
    `hedgeSecType`,
    `theoOpx`,
    `theoVol`,
    `childOrderMask`,
    `priceFormat`,
    `uPriceFormat`,
    `userName`,
    `timestamp`
FROM `SRTrade`.`MsgSRParentBrkrEvent`
WHERE 
    /* Replace with a CHAR(19) */
    `parentNumber` = 'Example_parentNumber'
  AND
    /* Replace with a ENUM('New','Modify','Replace','Close','Reject') */ 
    `recType` = 'New';

Doc Columns Query

SELECT * FROM SRTrade.doccolumns WHERE TABLE_NAME='SpdrParentBrkrEvent' ORDER BY ordinal_position ASC;

METADATA​

Table Definition​

PRIMARY KEY DEFINITION (Unique)​

CREATE TABLE EXAMPLE QUERY​

SELECT TABLE EXAMPLE QUERY​

Doc Columns Query​